<?php

require_once '../php/functions_adv.php';
require_once '../php/database.php';
require_once '../php/class.phpmailer.php';

// start session

session_start();





if (!isset($_SESSION['adv'])) {
    die ("ERROR: Unauthorized access!");
}

else {
	
	$data1 = $_SESSION['adv']->get_advisor_homepage();
	$adv_name = $data1['name'];
	$desc=$_POST['desc'];
	echo $desc;
	$reqid= $_GET['l1'];
	$student=$_GET['l2'];
	$timestamp=$_GET['l3'];
	//$versionid=$_GET['l4'];
	echo $student." ".$reqid." ".$timestamp." ";
	
	
	
	$db = new DatabaseManager();
	$connection = $db->getDB();
	
	
	$result = mysqli_query($connection,"SELECT * FROM advisor where name='$adv_name'");
	$temp = mysqli_fetch_array($result,MYSQLI_ASSOC);
	$ad_id=$temp['adv_id'];
	echo $ad_id;
	
	$result1 = mysqli_query($connection,"SELECT * FROM phd where name='$student'");
	$temp2 = mysqli_fetch_array($result1,MYSQLI_ASSOC);
	$p_id=$temp2['phd_id'];
	echo $p_id;
	
	
	$query = "call set_message(".$reqid.",'".$ad_id."','".$p_id."','".$desc."')";
	$result2 = mysqli_query($connection,$query);
	
	
	$newstatus='modified';
	$defaultvid='100';
	$db1 = new DatabaseManager();
	$connection1 = $db1->getDB();
	
	$query1 = "call change_status('".$ad_id."',".$reqid.",1,'modified')";
	$result3 = mysqli_query($connection1,$query1);
	
	//insert into message values (req_id,from_id,to_id,time_stamp,content);
	
/*	if($day=='dd' || $month=='mm' || $year=='yyyy')
		$timestamp="NULL";
	else
		$timestamp="$year"."/"."$month"."/"."$day";
*/	$db = new DatabaseManager();
	$connection = $db->getDB();
	//echo $_FILES['attachment']['size'];
	//echo isset($_POST['attachment'])?"SET!":"Not SET!!!!";
	//if(/*isset($_POST['attachment']) && */$_FILES['attachment']['size'] > 0)

	/*{
//$fileName = $_FILES['attachment']['name'];
$tmpName  = $_FILES['attachment']['tmp_name'];
$fileSize = $_FILES['attachment']['size'];
$fileType = $_FILES['attachment']['type'];

$fp      = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);

if(!get_magic_quotes_gpc())
{
    $fileName = addslashes($fileName);
}
$tarray = array("pid"=>$_SESSION['adv']->getID(),"adv"=>$_SESSION['adv']->getAdvisor(false),"itemN"=>$itemN,"price"=>$price,"itemselect"=>$itemselect,"priority"=>$priority,"filename"=>$fileName,"filetype"=>$fileType,"filesize"=>$fileSize,"attachment"=>$content,"comments"=>$desc);
$_SESSION['adv']->submitRequests($tarray);
} */
//else{
	
	
	
	//$tarray = array("pid"=>$_SESSION['adv']->getID(),"adv"=>$_SESSION['adv']->getAdvisor(false),"itemN"=>$itemN,"price"=>$price,"itemselect"=>$itemselect,"priority"=>$priority,"filename"=>"NULL","filetype"=>"NULL","filesize"=>"NULL","attachment"=>"NULL","comments"=>$desc);
	//$_SESSION['adv']->submitRequests($tarray);

	
	//}










	
	$mail             = new PHPMailer();
 	$body             = "Hello User <br> Here is the summary of what you have filled <br> ";
	$mail->Mailer = "smtp"; 
	$mail->Host = "ssl://smtp.gmail.com"; 
	$mail->Port = 465; 
	$mail->SMTPAuth = true; // turn on SMTP authentication 
	$mail->Username = "grantedteam"; // SMTP username 
	$mail->Password = "yomama123$"; // SMTP password 
	$mail->IsSMTP(); // telling the class to use SMTP
	$mail->SetFrom('grantedteam@gmail.com', 'Granted');
	$mail->Subject    = "Request Form Summary";
	$mail->AltBody    = " Here is the summary of the request form </br> you have submitted;"; // optional, comment out and test
	$mail->MsgHTML($body);
	
	
	
	//$mail->AddAddress('akshit10012@iiitd.ac.in', 'Akshit Gupta'); // NEEDS TO BE DYNAMICALLY PICKED UP
	/*if(!$mail->Send()) {
		echo "Mailer Error: " . $mail->ErrorInfo;
	} else {
  		echo "Message sent!";
	}*/
	
?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Granted v0.0</title>
<link rel="stylesheet" href="../css/screen.css" type="text/css" media="screen" title="default" />
<!--[if IE]>
<link rel="stylesheet" media="all" type="text/css" href="../css/pro_dropline_ie.css" />
<![endif]-->

<!--  jquery core -->
<script src="../js/jquery/jquery-1.4.1.min.js" type="text/javascript"></script>

<!--  checkbox styling script -->
<script src="../js/jquery/ui.core.js" type="text/javascript"></script>
<script src="../js/jquery/ui.checkbox.js" type="text/javascript"></script>
<script src="../js/jquery/jquery.bind.js" type="text/javascript"></script>
<script type="text/javascript">
$(function(){
	$('input').checkBox();
	$('#toggle-all').click(function(){
 	$('#toggle-all').toggleClass('toggle-checked');
	$('#mainform input[type=checkbox]').checkBox('toggle');
	return false;
	});
});
</script>  

<!--[if !IE 7]>

<!--  styled select box script version 1 -->
<script src="../js/jquery/jquery.selectbox-0.5.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function() {
	$('.styledselect').selectbox({ inputClass: "selectbox_styled" });
});
</script>
 

<!--[endif]>

<!--  styled select box script version 2 --> 
<script src="../js/jquery/jquery.selectbox-0.5_style_2.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function() {
	$('.styledselect_form_1').selectbox({ inputClass: "styledselect_form_1" });
	$('.styledselect_form_2').selectbox({ inputClass: "styledselect_form_2" });
});
</script>

<!--  styled select box script version 3 --> 
<script src="../js/jquery/jquery.selectbox-0.5_style_2.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function() {
	$('.styledselect_pages').selectbox({ inputClass: "styledselect_pages" });
});
</script>

<!--  styled file upload script --> 
<script src="../js/jquery/jquery.filestyle.js" type="text/javascript"></script>
<script type="text/javascript" charset="utf-8">
  $(function() {
      $("input.file_1").filestyle({ 
          image: "images/forms/choose-file.gif",
          imageheight : 21,
          imagewidth : 78,
          width : 310
      });
  });
</script>

<!-- Custom jquery scripts -->
<script src="../js/jquery/custom_jquery.js" type="text/javascript"></script>
 
<!-- Tooltips -->
<script src="../js/jquery/jquery.tooltip.js" type="text/javascript"></script>
<script src="../js/jquery/jquery.dimensions.js" type="text/javascript"></script>
<script type="text/javascript">
$(function() {
	$('a.info-tooltip ').tooltip({
		track: true,
		delay: 0,
		fixPNG: true, 
		showURL: false,
		showBody: " - ",
		top: -35,
		left: 5
	});
});
</script> 


<!--  date picker script -->
<link rel="stylesheet" href="../css/datePicker.css" type="text/css" />
<script src="../js/jquery/date.js" type="text/javascript"></script>
<script src="../js/jquery/jquery.datePicker.js" type="text/javascript"></script>
<script type="text/javascript" charset="utf-8">
        $(function()
{

// initialise the "Select date" link
$('#date-pick')
	.datePicker(
		// associate the link with a date picker
		{
			createButton:false,
			startDate:'01/01/2005',
			endDate:'31/12/2020'
		}
	).bind(
		// when the link is clicked display the date picker
		'click',
		function()
		{
			updateSelects($(this).dpGetSelected()[0]);
			$(this).dpDisplay();
			return false;
		}
	).bind(
		// when a date is selected update the SELECTs
		'dateSelected',
		function(e, selectedDate, $td, state)
		{
			updateSelects(selectedDate);
		}
	).bind(
		'dpClosed',
		function(e, selected)
		{
			updateSelects(selected[0]);
		}
	);
	
var updateSelects = function (selectedDate)
{
	var selectedDate = new Date(selectedDate);
	$('#d option[value=' + selectedDate.getDate() + ']').attr('selected', 'selected');
	$('#m option[value=' + (selectedDate.getMonth()+1) + ']').attr('selected', 'selected');
	$('#y option[value=' + (selectedDate.getFullYear()) + ']').attr('selected', 'selected');
}
// listen for when the selects are changed and update the picker
$('#d, #m, #y')
	.bind(
		'change',
		function()
		{
			var d = new Date(
						$('#y').val(),
						$('#m').val()-1,
						$('#d').val()
					);
			$('#date-pick').dpSetSelected(d.asString());
		}
	);

// default the position of the selects to today
var today = new Date();
updateSelects(today.getTime());

// and update the datePicker to reflect it...
$('#d').trigger('change');
});
</script>

<!-- MUST BE THE LAST SCRIPT IN <HEAD></HEAD></HEAD> png fix -->
<script src="../js/jquery/jquery.pngFix.pack.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function(){
$(document).pngFix( );
});
</script>
</head>
<body> 
<!-- Start: page-top-outer -->
<div id="page-top-outer">    

<!-- Start: page-top -->
<div id="page-top">

	<!-- start logo -->
	<div id="logo">
	<a href="../index.html"><img src="../images/shared/granted.png" width="300" height="50" alt="" /></a>
	</div>
	<!-- end logo -->
	
	<!--  start top-search -->
	<div id="top-search">
		<img src="../images/shared/IIITD_white__50.png	" widht="85" height="50" alt="" />
		
		<input type="image" src="../images/shared/top_search_btn.gif"  />
		</td>
		</tr>
		</table-->
	</div>
 	<!--  end top-search -->
 	<div class="clear"></div>

</div>
<!-- End: page-top -->

</div>
<!-- End: page-top-outer -->
	
<div class="clear">&nbsp;</div>
 
<!--  start nav-outer-repeat................................................................................................. START -->
<div class="nav-outer-repeat"> 
<!--  start nav-outer -->
<div class="nav-outer"> 

		<!-- start nav-right -->
		<div id="nav-right">
		
			
			<div class="nav-divider">&nbsp;</div>
			<a href="logout.php" id="logout"><img src="../images/shared/nav/nav_logout.gif" width="64" height="14" alt="" /></a>
			<div class="clear">&nbsp;</div>
						
			<!--  start account-content --->	
			<div class="account-content">
			<div class="account-drop-inner">
				<a href="../" id="acc-settings">Settings</a>
				<div class="clear">&nbsp;</div>
				<div class="acc-line">&nbsp;</div>
				<a href="../" id="acc-details">Personal details </a>
				<div class="clear">&nbsp;</div>
				<div class="acc-line">&nbsp;</div>
				<a href="../" id="acc-inbox">Inbox</a>
			</div>
			</div>
			<!--  end account-content -->
		
		</div>
		<!-- end nav-right -->


		<!--  start nav -->
		<div class="nav">
		<div class="table">
		
		<ul class="current"><li><a href="home.php"><b>Dashboard</b><!--[if IE 7]><!--></a><!--<![endif]-->
		<!--[if lte IE 6]><table><tr><td><![endif]-->
		<!--div class="select_sub">
			<ul class="sub">
				<li><a href="../#nogo">Dashboard Details 1</a></li>
				<li><a href="../#nogo">Dashboard Details 2</a></li>
				<li><a href="../#nogo">Dashboard Details 3</a></li>
			</ul>
		</div>
		<!--[if lte IE 6]></td></tr></table></a><![endif]-->
		</li>
		</ul>
		
		<div class="nav-divider">&nbsp;</div>
		                    
		<ul class="select"><li><a href="table.php"><b>Requests</b><!--[if IE 7]><!--></a><!--<![endif]-->
		<!--[if lte IE 6]><table><tr><td><![endif]-->
		
		<!--[if lte IE 6]></td></tr></table></a><![endif]-->
		</li>
		</ul>
		
		<div class="nav-divider">&nbsp;</div>
		
		<ul class="select"><li><a href="archive.php"><b>Archives</b><!--[if IE 7]><!--></a><!--<![endif]-->
		<!--[if lte IE 6]><table><tr><td><![endif]-->
		<!--div class="select_sub">
			<ul class="sub">
				<li><a href="../#nogo">Categories Details 1</a></li>
				<li><a href="../#nogo">Categories Details 2</a></li>
				<li><a href="../#nogo">Categories Details 3</a></li>
			</ul>
		</div>


		<!--[if lte IE 6]></td></tr></table></a><![endif]-->
		</li>
		</ul>
		
		
		<div class="nav-divider">&nbsp;</div>
		
		<ul class="select"><li><a href="list.php"><b>PHD Students</b><!--[if IE 7]><!--></a><!--<![endif]-->
		<!--[if lte IE 6]><table><tr><td><![endif]-->
		<!--div class="select_sub">
			<ul class="sub">
				<li><a href="../#nogo">Categories Details 1</a></li>
				<li><a href="../#nogo">Categories Details 2</a></li>
				<li><a href="../#nogo">Categories Details 3</a></li>
			</ul>
		</div>


		<!--[if lte IE 6]></td></tr></table></a><![endif]-->
		</li>
		</ul>
		
		
		
		<div class="nav-divider">&nbsp;</div>
		
		<ul class="select"><li><a href="inbox.php"><b>Inbox</b><!--[if IE 7]><!--></a><!--<![endif]-->
		<!--[if lte IE 6]><table><tr><td><![endif]-->
		
		<!--[if lte IE 6]></td></tr></table></a><![endif]-->
		</li>
		</ul>
		
		
		<!--[if lte IE 6]></td></tr></table></a><![endif]-->

		
		<!--ul class="select"><li><a href="../#nogo"><b>News</b><!--[if IE 7]><!--></a><!--<![endif]-->
		<!--[if lte IE 6]><table><tr><td><![endif]-->
		<!--div class="select_sub">
			<ul class="sub">
				<li><a href="../#nogo">News details 1</a></li>
				<li><a href="../#nogo">News details 2</a></li>
				<li><a href="../#nogo">News details 3</a></li>
			</ul>
		</div>
		<!--[if lte IE 6]></td></tr></table></a><![endif]-->
		<!-- /li>
		</ul -->
		
		<div class="clear"></div>
		</div>
		<div class="clear"></div>
		</div>
		<!--  start nav -->

</div>
<div class="clear"></div>
<!--  start nav-outer -->
</div>
<!--  start nav-outer-repeat................................................... END -->

 <div class="clear"></div>
 
<!-- start content-outer ........................................................................................................................START -->
<div id="content-outer">
<!-- start content -->
<div id="content">

	<!--  start page-heading -->
	<div id="page-heading">

	</div>
	<!-- end page-heading -->

	<table border="0" width="100%" cellpadding="0" cellspacing="0" id="content-table">
	<tr>
		<th class="topleft"></th>
		<td id="tbl-border-top">&nbsp;</td>
		<th class="topright"></th>
	</tr>
	<tr>
		<td id="tbl-border-left"></td>
		<td>
		<!--  start content-table-inner ...................................................................... START -->
		<div id="content-table-inner">
		
			<!--  start table-content  -->
			<div id="table-content">
			<div style="width:50%;float:right;">
			<div id="message-blue" >
			
				<table border="0" width="100%" cellpadding="0" cellspacing="0">
				</table>
			</div>
            <?php
			$_SESSION['adv']->displayNotifications();
			?>
			</div>
			
			<div width="400px" style="padding:20px;">
			<div id="table-content">
<table border="0" cellpadding="10" cellspacing="10" style="padding:20px;">
<tr>
<p><h1> <strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Suggestion Sent</strong></p>
&nbsp;<h1></p></td>

<p><h3> <strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; The mail regarding the modifed request has been sent to the student</strong></p>
&nbsp;<h3></p></td>
</tr>
</table>
</div>
			
			</div>
			</div>
			<!--  end table-content  -->
	
			<div class="clear"></div>
		 
		</div>
		<!--  end content-table-inner ............................................END  -->
		</td>
		<td id="tbl-border-right"></td>
	</tr>
	<tr>
		<th class="sized bottomleft"></th>
		<td id="tbl-border-bottom">&nbsp;</td>
		<th class="sized bottomright"></th>
	</tr>
	</table>
	<div class="clear">&nbsp;</div>

</div>
<!--  end content -->
<div class="clear">&nbsp;</div>
</div>
<!--  end content-outer........................................................END -->

<div class="clear">&nbsp;</div>
    
<!-- start footer -->         
<div id="footer">
<!-- <div id="footer-pad">&nbsp;</div> -->
	<!--  start footer-left -->
	<div id="footer-left">
	Granted&copy;	 <span id="spanYear"></span> <a href="../">iiitd.ac.in</a>. All rights reserved.</div>
	<!--  end footer-left -->
	<div class="clear">&nbsp;</div>
</div>
<!-- end footer -->
 
</body>
</html>
<?php
}
?>